insert overwrite table jms_dm.dm_mng_thd_flase_send_network_summary_hisver_dt partition (dt)
select '{{ execution_date | cst_ds }}' as date_time
     , first_duty_network_code
     , first_duty_network_name
     , first_duty_network_type
     , first_duty_agent_code
     , first_duty_agent_name
     , all_num
     , first_line_num
     , outprov_center_num
     , same_center_num
     , adjacent_track
     , date_time                       as update_time
     , '{{ execution_date | cst_ds }}' as dt
from jms_dm.dm_mng_thd_flase_send_network_summary_dt
where dt <= '{{ execution_date | cst_ds }}'
  and dt >= date_add('{{ execution_date | cst_ds }}', -30)
    distribute by dt
;
